﻿/********************************************************************************************************************
* Author:	Aris Michail																							*
* Email:	std03055@di.uoa.gr																						*
* Purpose:	This script is used in order to create the stored procedure "usp_activateCategory" that activates a		*
*			category.																								*
********************************************************************************************************************/

CREATE PROCEDURE [dbo].[usp_activateCategory]
	@categoryid bigint
AS
	UPDATE Categories
	SET IsApproved = '1'
	WHERE Categories.ID = @categoryid
RETURN 0